package cn.ichiva.luckysheet.utils;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;

import java.util.regex.Pattern;

/**
 * TODO
 *
 * @author pzq
 * @version 1.0
 * @date 2022/1/12 16:46
 */
public class JsonUtil {
    private static Pattern pattern = Pattern.compile("^[-\\+]?[\\d]*$");
    public static void main(String[] args) {
        String mb="{\"loopBlockList\":[],\"area\":{\"sri\":1,\"sci\":4,\"eri\":1,\"eci\":8,\"width\":508,\"height\":54},\"excel_config_id\":\"590812531803901952\",\"printConfig\":{\"paper\":\"A4\",\"width\":210,\"height\":297,\"definition\":1,\"isBackend\":false,\"marginX\":10,\"marginY\":10,\"layout\":\"portrait\"},\"zonedEditionList\":[],\"rows\":{\"0\":{\"cells\":{\"3\":{\"style\":27,\"text\":\"\"},\"5\":{\"text\":\"\"},\"7\":{\"merge\":[0,2],\"style\":27,\"height\":56}},\"height\":59},\"1\":{\"cells\":{\"1\":{\"merge\":[0,2],\"style\":27,\"text\":\"纵向分组小计示例2\",\"height\":56},\"4\":{\"merge\":[0,4],\"style\":29,\"text\":\"说明：区域(areaname)、省份(dept)纵向分组；单价(price)、金额(amount)设置动态属性；小计设置compute行内计算compute(price*amount)；参考文档：http://report.jeecg.com/2333594\",\"height\":54},\"5\":{\"style\":30},\"6\":{\"style\":30},\"7\":{\"style\":30},\"8\":{\"style\":30}},\"height\":54},\"2\":{\"cells\":{\"1\":{\"merge\":[2,0],\"style\":21,\"text\":\"区域\",\"height\":81},\"2\":{\"merge\":[2,0],\"style\":21,\"text\":\"省份\",\"height\":81},\"3\":{\"merge\":[0,5],\"style\":21,\"text\":\"2020年\",\"height\":31,\"aggregate\":\"group\",\"direction\":\"right\"},\"9\":{\"merge\":[0,5],\"style\":21,\"text\":\"2021年\",\"height\":31,\"aggregate\":\"group\",\"direction\":\"right\"}},\"height\":35},\"3\":{\"cells\":{\"12\":{\"merge\":[0,2],\"style\":21,\"text\":\"2月\",\"height\":25,\"aggregate\":\"group\",\"direction\":\"right\"},\"3\":{\"merge\":[0,2],\"style\":21,\"text\":\"1月\",\"height\":25,\"aggregate\":\"group\",\"direction\":\"right\"},\"6\":{\"merge\":[0,2],\"style\":21,\"text\":\"2月\",\"height\":25,\"aggregate\":\"group\",\"direction\":\"right\"},\"9\":{\"merge\":[0,2],\"style\":21,\"text\":\"1月\",\"height\":25,\"aggregate\":\"group\",\"direction\":\"right\"}},\"height\":34},\"4\":{\"cells\":{\"11\":{\"style\":21,\"text\":\"小计\"},\"12\":{\"style\":21,\"text\":\"单价\"},\"13\":{\"style\":21,\"text\":\"金额\"},\"3\":{\"style\":21,\"text\":\"单价\"},\"14\":{\"style\":21,\"text\":\"小计\"},\"4\":{\"style\":21,\"text\":\"金额\"},\"5\":{\"style\":21,\"text\":\"小计\"},\"6\":{\"style\":21,\"text\":\"单价\"},\"7\":{\"style\":21,\"text\":\"金额\"},\"8\":{\"style\":21,\"text\":\"小计\"},\"9\":{\"style\":21,\"text\":\"单价\"},\"10\":{\"style\":21,\"text\":\"金额\"}},\"height\":35},\"5\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1218\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"204\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1224\",\"aggregate\":\"dynamic\"},\"1\":{\"funcname\":\"\",\"subtotal\":\"groupField\",\"style\":17,\"text\":\"华东\",\"aggregate\":\"group\",\"cellIndex\":\"1\",\"rowIndex\":\"7\",\"merge\":[2,0]},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"天津\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"203\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1218\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"204\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1224\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"203\",\"aggregate\":\"dynamic\"}},\"height\":37},\"6\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1218\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"204\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1224\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"辽宁\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"203\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1218\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"204\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1224\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"203\",\"aggregate\":\"dynamic\"}},\"height\":37},\"7\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"408\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"合计\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"406\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"408\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"406\",\"aggregate\":\"dynamic\"}},\"height\":37},\"8\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1000\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"201\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1005\",\"aggregate\":\"dynamic\"},\"1\":{\"funcname\":\"\",\"subtotal\":\"groupField\",\"style\":17,\"text\":\"华北\",\"aggregate\":\"group\",\"cellIndex\":\"1\",\"rowIndex\":\"10\",\"merge\":[2,0]},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"河北\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"100\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"500\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"200\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1000\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"200\",\"aggregate\":\"dynamic\"}},\"height\":37},\"9\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1254\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"202\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1212\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"河南\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"202\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1212\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"202\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1212\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"6\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"209\",\"aggregate\":\"dynamic\"}},\"height\":37},\"10\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"403\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"合计\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"302\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"402\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"409\",\"aggregate\":\"dynamic\"}},\"height\":37},\"11\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1035\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"208\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1040\",\"aggregate\":\"dynamic\"},\"1\":{\"funcname\":\"\",\"subtotal\":\"groupField\",\"style\":17,\"text\":\"华南\",\"aggregate\":\"group\",\"cellIndex\":\"1\",\"rowIndex\":\"13\",\"merge\":[2,0]},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"安徽\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"207\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1035\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"208\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1040\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"207\",\"aggregate\":\"dynamic\"}},\"height\":37},\"12\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1025\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"206\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1030\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"湖北\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"205\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1025\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"206\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"1030\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"5\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"205\",\"aggregate\":\"dynamic\"}},\"height\":37},\"13\":{\"cells\":{\"11\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"12\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"13\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"414\",\"aggregate\":\"dynamic\"},\"14\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"2\":{\"funcname\":\"\",\"style\":17,\"text\":\"合计\",\"aggregate\":\"group\"},\"3\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"4\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"412\",\"aggregate\":\"dynamic\"},\"5\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"6\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"7\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"414\",\"aggregate\":\"dynamic\"},\"8\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"9\":{\"style\":26,\"text\":\"\",\"aggregate\":\"dynamic\"},\"10\":{\"funcname\":\"SUM\",\"subtotal\":\"\",\"style\":26,\"text\":\"412\",\"aggregate\":\"dynamic\"}},\"height\":37},\"14\":{\"cells\":{\"-1\":{\"text\":\"天津\"}}},\"15\":{\"cells\":{\"-1\":{\"text\":\"天津\"}}},\"16\":{\"cells\":{\"-1\":{\"text\":\"天津\"}}},\"17\":{\"cells\":{\"-1\":{\"text\":\"天津\"}}},\"18\":{\"cells\":{\"-1\":{\"text\":\"辽宁\"}}},\"19\":{\"cells\":{\"-1\":{\"text\":\"辽宁\"}}},\"20\":{\"cells\":{\"-1\":{\"text\":\"辽宁\"}}},\"21\":{\"cells\":{\"-1\":{\"text\":\"辽宁\"}}},\"22\":{\"cells\":{\"-1\":{\"text\":\"河北\"}}},\"23\":{\"cells\":{\"-1\":{\"text\":\"河北\"}}},\"24\":{\"cells\":{\"-1\":{\"text\":\"河北\"}}},\"25\":{\"cells\":{\"-1\":{\"text\":\"河北\"}}},\"26\":{\"cells\":{\"-1\":{\"text\":\"河南\"}}},\"27\":{\"cells\":{\"-1\":{\"text\":\"河南\"}}},\"28\":{\"cells\":{\"-1\":{\"text\":\"河南\"}}},\"29\":{\"cells\":{\"-1\":{\"text\":\"河南\"}}},\"30\":{\"cells\":{\"-1\":{\"text\":\"安徽\"}}},\"31\":{\"cells\":{\"-1\":{\"text\":\"安徽\"}}},\"32\":{\"cells\":{\"-1\":{\"text\":\"安徽\"}}},\"33\":{\"cells\":{\"-1\":{\"text\":\"安徽\"}}},\"34\":{\"cells\":{\"-1\":{\"text\":\"湖北\"}}},\"35\":{\"cells\":{\"-1\":{\"text\":\"湖北\"}}},\"36\":{\"cells\":{\"-1\":{\"text\":\"湖北\"}}},\"37\":{\"cells\":{\"-1\":{\"text\":\"湖北\"}}},\"39\":{\"cells\":{\"1\":{\"merge\":[2,5],\"style\":28,\"text\":\"\",\"height\":75},\"2\":{},\"3\":{},\"4\":{},\"5\":{},\"6\":{}}},\"40\":{\"cells\":{\"1\":{},\"2\":{},\"3\":{},\"4\":{},\"5\":{},\"6\":{}}},\"41\":{\"cells\":{\"1\":{},\"2\":{},\"3\":{},\"4\":{},\"5\":{},\"6\":{}}},\"len\":61},\"dbexps\":[],\"dicts\":[],\"rpbar\":{\"show\":true,\"pageSize\":\"\",\"btnList\":[]},\"groupField\":\"jm.areaname\",\"freeze\":\"A1\",\"dataRectWidth\":456,\"displayConfig\":{},\"background\":false,\"name\":\"sheet1\",\"autofilter\":{},\"styles\":[{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]}},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#d8d8d8\"},{\"bgcolor\":\"#d8d8d8\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#71ae47\"},{\"bgcolor\":\"#71ae47\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#c45a10\"},{\"bgcolor\":\"#c45a10\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#7f7f7f\"},{\"bgcolor\":\"#7f7f7f\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#ffffff\"},{\"bgcolor\":\"#ffffff\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#5b9cd6\"},{\"bgcolor\":\"#5b9cd6\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#d0cecf\"},{\"bgcolor\":\"#d0cecf\"},{\"border\":{\"bottom\":[\"thin\",\"#000\"],\"top\":[\"thin\",\"#000\"],\"left\":[\"thin\",\"#000\"],\"right\":[\"thin\",\"#000\"]},\"bgcolor\":\"#f2f2f2\"},{\"bgcolor\":\"#f2f2f2\"},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]}},{\"border\":{\"bottom\":[\"thin\",\"#0c0c0c\"],\"top\":[\"thin\",\"#0c0c0c\"],\"left\":[\"thin\",\"#0c0c0c\"],\"right\":[\"thin\",\"#0c0c0c\"]}},{\"border\":{\"bottom\":[\"thin\",\"#262626\"],\"top\":[\"thin\",\"#262626\"],\"left\":[\"thin\",\"#262626\"],\"right\":[\"thin\",\"#262626\"]}},{\"border\":{\"bottom\":[\"thin\",\"#3f3f3f\"],\"top\":[\"thin\",\"#3f3f3f\"],\"left\":[\"thin\",\"#3f3f3f\"],\"right\":[\"thin\",\"#3f3f3f\"]}},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]},\"bgcolor\":\"#f2f2f2\"},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]},\"bgcolor\":\"#d0cecf\"},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]},\"bgcolor\":\"#e7e5e6\"},{\"bgcolor\":\"#e7e5e6\"},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]},\"bgcolor\":\"#d8d8d8\"},{\"border\":{\"bottom\":[\"thin\",\"#000100\"],\"top\":[\"thin\",\"#000100\"],\"left\":[\"thin\",\"#000100\"],\"right\":[\"thin\",\"#000100\"]},\"format\":\"number\"},{\"font\":{\"size\":15}},{\"textwrap\":true},{\"textwrap\":true,\"color\":\"#fe0000\"},{\"color\":\"#fe0000\"}],\"validations\":[],\"isGroup\":true,\"cols\":{\"0\":{\"width\":99},\"1\":{\"width\":80},\"2\":{\"width\":81},\"3\":{\"width\":65},\"4\":{\"width\":64},\"5\":{\"width\":67},\"8\":{\"width\":67},\"len\":20,\"6\":{\"width\":65},\"7\":{\"width\":64},\"9\":{\"width\":65},\"10\":{\"width\":64},\"11\":{\"width\":67},\"12\":{\"width\":65},\"13\":{\"width\":64},\"14\":{\"width\":67}},\"merges\":[\"H1:J1\",\"B3:B5\",\"C3:C5\",\"D3:F3\",\"D4:F4\",\"B8:G10\",\"E2:I2\",\"B2:D2\",\"B3:B3\",\"C3:C3\",\"D3:I3\",\"J3:O3\",\"M4:O4\",\"D4:F4\",\"G4:I4\",\"J4:L4\",\"B10:B12\",\"B13:B15\",\"B7:B9\"]}";
        JSONObject jsonObject =(JSONObject) JSONObject.parse(mb);
        String a="51f";
        if(pattern.matcher(a).matches()){
            System.out.println("为整数");
        }else {
            System.out.println("不为整数");
        }


//        jsonObject.get()
    }
}
